Tabela LCareTakerContact

Definicja tabeli LCareTakerContact

Name

LCareTakerContact

Code

LCareTakerContact

Comment

PL: Polaczenie opiekuna z danymi kontaktowymi
EN: Link between curator and contact data


Lista kolumn tabeli LCareTakerContact

Name

Code

CareTakerID

CareTakerID

ContactID

ContactID

StartDT

StartDT

StopDT

StopDT


Kolumna CareTakerID tabeli LCareTakerContact

Definicja kolumny CareTakerID tabeli LCareTakerContact

Name

CareTakerID

Code

CareTakerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContactID tabeli LCareTakerContact

Definicja kolumny ContactID tabeli LCareTakerContact

Name

ContactID

Code

ContactID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LCareTakerContact

Definicja kolumny StartDT tabeli LCareTakerContact

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LCareTakerContact

Definicja kolumny StopDT tabeli LCareTakerContact

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LCareTakerContact

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LCareTakerContact

Definicja klucza Identifier_1 tabeli LCareTakerContact

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment